﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="CDmDjkRoute" targetNamespace="http://tempuri.org/CDmDjkRoute.xsd" xmlns:mstns="http://tempuri.org/CDmDjkRoute.xsd" xmlns="http://tempuri.org/CDmDjkRoute.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="dijiekeConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="dijiekeConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.msBsc.Xsd.DataTds.Properties.Settings.GlobalReference.Default.dijiekeConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DJK_ROUTETableAdapter" GeneratorDataComponentClassName="DJK_ROUTETableAdapter" Name="DJK_ROUTE" UserDataComponentName="DJK_ROUTETableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dijiekeConnectionString (Settings)" DbObjectName="dijieke.dbo.DJK_ROUTE" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DJK_ROUTE] WHERE (([ROUTE_ID] = @Original_ROUTE_ID) AND ((@IsNull_ROUTE_TITEL = 1 AND [ROUTE_TITEL] IS NULL) OR ([ROUTE_TITEL] = @Original_ROUTE_TITEL)) AND ((@IsNull_INTRODUCTION = 1 AND [INTRODUCTION] IS NULL) OR ([INTRODUCTION] = @Original_INTRODUCTION)) AND ((@IsNull_ROUTE_CHARACTERISTIC = 1 AND [ROUTE_CHARACTERISTIC] IS NULL) OR ([ROUTE_CHARACTERISTIC] = @Original_ROUTE_CHARACTERISTIC)) AND ((@IsNull_ROUTE_COUNTRY = 1 AND [ROUTE_COUNTRY] IS NULL) OR ([ROUTE_COUNTRY] = @Original_ROUTE_COUNTRY)) AND ((@IsNull_ROUTE_PROVINCE = 1 AND [ROUTE_PROVINCE] IS NULL) OR ([ROUTE_PROVINCE] = @Original_ROUTE_PROVINCE)) AND ((@IsNull_ROUTE_AREA = 1 AND [ROUTE_AREA] IS NULL) OR ([ROUTE_AREA] = @Original_ROUTE_AREA)) AND ((@IsNull_COVERAGE_SCENIC_SPOTS = 1 AND [COVERAGE_SCENIC_SPOTS] IS NULL) OR ([COVERAGE_SCENIC_SPOTS] = @Original_COVERAGE_SCENIC_SPOTS)) AND ((@IsNull_COVERAGE_AREA = 1 AND [COVERAGE_AREA] IS NULL) OR ([COVERAGE_AREA] = @Original_COVERAGE_AREA)) AND ((@IsNull_IMAGE_EXPLAIN = 1 AND [IMAGE_EXPLAIN] IS NULL) OR ([IMAGE_EXPLAIN] = @Original_IMAGE_EXPLAIN)) AND ((@IsNull_ROUTE_INTRODUCTION = 1 AND [ROUTE_INTRODUCTION] IS NULL) OR ([ROUTE_INTRODUCTION] = @Original_ROUTE_INTRODUCTION)) AND ((@IsNull_ROUTE_PRIC = 1 AND [ROUTE_PRIC] IS NULL) OR ([ROUTE_PRIC] = @Original_ROUTE_PRIC)) AND ((@IsNull_CREATE_TIME = 1 AND [CREATE_TIME] IS NULL) OR ([CREATE_TIME] = @Original_CREATE_TIME)) AND ([IS_DELETE] = @Original_IS_DELETE) AND ([IS_DJKINFO] = @Original_IS_DJKINFO))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ROUTE_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_TITEL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_TITEL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ROUTE_TITEL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_TITEL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_INTRODUCTION" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INTRODUCTION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_INTRODUCTION" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="INTRODUCTION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_CHARACTERISTIC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_CHARACTERISTIC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ROUTE_CHARACTERISTIC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_CHARACTERISTIC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_COUNTRY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_COUNTRY" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ROUTE_COUNTRY" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_COUNTRY" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_PROVINCE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_PROVINCE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ROUTE_PROVINCE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_PROVINCE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_AREA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_AREA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ROUTE_AREA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_AREA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COVERAGE_SCENIC_SPOTS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COVERAGE_SCENIC_SPOTS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_COVERAGE_SCENIC_SPOTS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COVERAGE_SCENIC_SPOTS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COVERAGE_AREA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COVERAGE_AREA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_COVERAGE_AREA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COVERAGE_AREA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IMAGE_EXPLAIN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IMAGE_EXPLAIN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_IMAGE_EXPLAIN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IMAGE_EXPLAIN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_INTRODUCTION" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_INTRODUCTION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ROUTE_INTRODUCTION" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_INTRODUCTION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_PRIC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_PRIC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ROUTE_PRIC" Precision="8" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ROUTE_PRIC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CREATE_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CREATE_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CREATE_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CREATE_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IS_DELETE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_DELETE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IS_DJKINFO" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_DJKINFO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DJK_ROUTE] ([ROUTE_ID], [ROUTE_TITEL], [INTRODUCTION], [ROUTE_CHARACTERISTIC], [ROUTE_COUNTRY], [ROUTE_PROVINCE], [ROUTE_AREA], [COVERAGE_SCENIC_SPOTS], [COVERAGE_AREA], [IMAGE_EXPLAIN], [ROUTE_INTRODUCTION], [ROUTE_PRIC], [CREATE_TIME], [IS_DELETE], [IS_DJKINFO]) VALUES (@ROUTE_ID, @ROUTE_TITEL, @INTRODUCTION, @ROUTE_CHARACTERISTIC, @ROUTE_COUNTRY, @ROUTE_PROVINCE, @ROUTE_AREA, @COVERAGE_SCENIC_SPOTS, @COVERAGE_AREA, @IMAGE_EXPLAIN, @ROUTE_INTRODUCTION, @ROUTE_PRIC, @CREATE_TIME, @IS_DELETE, @IS_DJKINFO);
SELECT ROUTE_ID, ROUTE_TITEL, INTRODUCTION, ROUTE_CHARACTERISTIC, ROUTE_COUNTRY, ROUTE_PROVINCE, ROUTE_AREA, COVERAGE_SCENIC_SPOTS, COVERAGE_AREA, IMAGE_EXPLAIN, ROUTE_INTRODUCTION, ROUTE_PRIC, CREATE_TIME, IS_DELETE, IS_DJKINFO FROM DJK_ROUTE WHERE (ROUTE_ID = @ROUTE_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ROUTE_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ROUTE_TITEL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_TITEL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@INTRODUCTION" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="INTRODUCTION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ROUTE_CHARACTERISTIC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_CHARACTERISTIC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ROUTE_COUNTRY" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_COUNTRY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ROUTE_PROVINCE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_PROVINCE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ROUTE_AREA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_AREA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COVERAGE_SCENIC_SPOTS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COVERAGE_SCENIC_SPOTS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COVERAGE_AREA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COVERAGE_AREA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IMAGE_EXPLAIN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IMAGE_EXPLAIN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ROUTE_INTRODUCTION" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_INTRODUCTION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ROUTE_PRIC" Precision="8" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ROUTE_PRIC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CREATE_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CREATE_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IS_DELETE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_DELETE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IS_DJKINFO" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_DJKINFO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ROUTE_ID, ROUTE_TITEL, INTRODUCTION, ROUTE_CHARACTERISTIC, ROUTE_COUNTRY, ROUTE_PROVINCE, ROUTE_AREA, COVERAGE_SCENIC_SPOTS, COVERAGE_AREA, IMAGE_EXPLAIN, ROUTE_INTRODUCTION, ROUTE_PRIC, CREATE_TIME, IS_DELETE, IS_DJKINFO FROM dbo.DJK_ROUTE</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DJK_ROUTE] SET [ROUTE_ID] = @ROUTE_ID, [ROUTE_TITEL] = @ROUTE_TITEL, [INTRODUCTION] = @INTRODUCTION, [ROUTE_CHARACTERISTIC] = @ROUTE_CHARACTERISTIC, [ROUTE_COUNTRY] = @ROUTE_COUNTRY, [ROUTE_PROVINCE] = @ROUTE_PROVINCE, [ROUTE_AREA] = @ROUTE_AREA, [COVERAGE_SCENIC_SPOTS] = @COVERAGE_SCENIC_SPOTS, [COVERAGE_AREA] = @COVERAGE_AREA, [IMAGE_EXPLAIN] = @IMAGE_EXPLAIN, [ROUTE_INTRODUCTION] = @ROUTE_INTRODUCTION, [ROUTE_PRIC] = @ROUTE_PRIC, [CREATE_TIME] = @CREATE_TIME, [IS_DELETE] = @IS_DELETE, [IS_DJKINFO] = @IS_DJKINFO WHERE (([ROUTE_ID] = @Original_ROUTE_ID) AND ((@IsNull_ROUTE_TITEL = 1 AND [ROUTE_TITEL] IS NULL) OR ([ROUTE_TITEL] = @Original_ROUTE_TITEL)) AND ((@IsNull_INTRODUCTION = 1 AND [INTRODUCTION] IS NULL) OR ([INTRODUCTION] = @Original_INTRODUCTION)) AND ((@IsNull_ROUTE_CHARACTERISTIC = 1 AND [ROUTE_CHARACTERISTIC] IS NULL) OR ([ROUTE_CHARACTERISTIC] = @Original_ROUTE_CHARACTERISTIC)) AND ((@IsNull_ROUTE_COUNTRY = 1 AND [ROUTE_COUNTRY] IS NULL) OR ([ROUTE_COUNTRY] = @Original_ROUTE_COUNTRY)) AND ((@IsNull_ROUTE_PROVINCE = 1 AND [ROUTE_PROVINCE] IS NULL) OR ([ROUTE_PROVINCE] = @Original_ROUTE_PROVINCE)) AND ((@IsNull_ROUTE_AREA = 1 AND [ROUTE_AREA] IS NULL) OR ([ROUTE_AREA] = @Original_ROUTE_AREA)) AND ((@IsNull_COVERAGE_SCENIC_SPOTS = 1 AND [COVERAGE_SCENIC_SPOTS] IS NULL) OR ([COVERAGE_SCENIC_SPOTS] = @Original_COVERAGE_SCENIC_SPOTS)) AND ((@IsNull_COVERAGE_AREA = 1 AND [COVERAGE_AREA] IS NULL) OR ([COVERAGE_AREA] = @Original_COVERAGE_AREA)) AND ((@IsNull_IMAGE_EXPLAIN = 1 AND [IMAGE_EXPLAIN] IS NULL) OR ([IMAGE_EXPLAIN] = @Original_IMAGE_EXPLAIN)) AND ((@IsNull_ROUTE_INTRODUCTION = 1 AND [ROUTE_INTRODUCTION] IS NULL) OR ([ROUTE_INTRODUCTION] = @Original_ROUTE_INTRODUCTION)) AND ((@IsNull_ROUTE_PRIC = 1 AND [ROUTE_PRIC] IS NULL) OR ([ROUTE_PRIC] = @Original_ROUTE_PRIC)) AND ((@IsNull_CREATE_TIME = 1 AND [CREATE_TIME] IS NULL) OR ([CREATE_TIME] = @Original_CREATE_TIME)) AND ([IS_DELETE] = @Original_IS_DELETE) AND ([IS_DJKINFO] = @Original_IS_DJKINFO));
SELECT ROUTE_ID, ROUTE_TITEL, INTRODUCTION, ROUTE_CHARACTERISTIC, ROUTE_COUNTRY, ROUTE_PROVINCE, ROUTE_AREA, COVERAGE_SCENIC_SPOTS, COVERAGE_AREA, IMAGE_EXPLAIN, ROUTE_INTRODUCTION, ROUTE_PRIC, CREATE_TIME, IS_DELETE, IS_DJKINFO FROM DJK_ROUTE WHERE (ROUTE_ID = @ROUTE_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ROUTE_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ROUTE_TITEL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_TITEL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@INTRODUCTION" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="INTRODUCTION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ROUTE_CHARACTERISTIC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_CHARACTERISTIC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ROUTE_COUNTRY" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_COUNTRY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ROUTE_PROVINCE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_PROVINCE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ROUTE_AREA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_AREA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COVERAGE_SCENIC_SPOTS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COVERAGE_SCENIC_SPOTS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COVERAGE_AREA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COVERAGE_AREA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IMAGE_EXPLAIN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IMAGE_EXPLAIN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ROUTE_INTRODUCTION" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_INTRODUCTION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ROUTE_PRIC" Precision="8" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ROUTE_PRIC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CREATE_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CREATE_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IS_DELETE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_DELETE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IS_DJKINFO" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_DJKINFO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ROUTE_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_TITEL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_TITEL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ROUTE_TITEL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_TITEL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_INTRODUCTION" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INTRODUCTION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_INTRODUCTION" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="INTRODUCTION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_CHARACTERISTIC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_CHARACTERISTIC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ROUTE_CHARACTERISTIC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_CHARACTERISTIC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_COUNTRY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_COUNTRY" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ROUTE_COUNTRY" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_COUNTRY" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_PROVINCE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_PROVINCE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ROUTE_PROVINCE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_PROVINCE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_AREA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_AREA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ROUTE_AREA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_AREA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COVERAGE_SCENIC_SPOTS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COVERAGE_SCENIC_SPOTS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_COVERAGE_SCENIC_SPOTS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COVERAGE_SCENIC_SPOTS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COVERAGE_AREA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COVERAGE_AREA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_COVERAGE_AREA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="COVERAGE_AREA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IMAGE_EXPLAIN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IMAGE_EXPLAIN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_IMAGE_EXPLAIN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IMAGE_EXPLAIN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_INTRODUCTION" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_INTRODUCTION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ROUTE_INTRODUCTION" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ROUTE_INTRODUCTION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_PRIC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_PRIC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ROUTE_PRIC" Precision="8" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ROUTE_PRIC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CREATE_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CREATE_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CREATE_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CREATE_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IS_DELETE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_DELETE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IS_DJKINFO" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_DJKINFO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ROUTE_ID" DataSetColumn="ROUTE_ID" />
              <Mapping SourceColumn="ROUTE_TITEL" DataSetColumn="ROUTE_TITEL" />
              <Mapping SourceColumn="INTRODUCTION" DataSetColumn="INTRODUCTION" />
              <Mapping SourceColumn="ROUTE_CHARACTERISTIC" DataSetColumn="ROUTE_CHARACTERISTIC" />
              <Mapping SourceColumn="ROUTE_COUNTRY" DataSetColumn="ROUTE_COUNTRY" />
              <Mapping SourceColumn="ROUTE_PROVINCE" DataSetColumn="ROUTE_PROVINCE" />
              <Mapping SourceColumn="ROUTE_AREA" DataSetColumn="ROUTE_AREA" />
              <Mapping SourceColumn="COVERAGE_SCENIC_SPOTS" DataSetColumn="COVERAGE_SCENIC_SPOTS" />
              <Mapping SourceColumn="COVERAGE_AREA" DataSetColumn="COVERAGE_AREA" />
              <Mapping SourceColumn="IMAGE_EXPLAIN" DataSetColumn="IMAGE_EXPLAIN" />
              <Mapping SourceColumn="ROUTE_INTRODUCTION" DataSetColumn="ROUTE_INTRODUCTION" />
              <Mapping SourceColumn="ROUTE_PRIC" DataSetColumn="ROUTE_PRIC" />
              <Mapping SourceColumn="CREATE_TIME" DataSetColumn="CREATE_TIME" />
              <Mapping SourceColumn="IS_DELETE" DataSetColumn="IS_DELETE" />
              <Mapping SourceColumn="IS_DJKINFO" DataSetColumn="IS_DJKINFO" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="CDmDjkRoute" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="CDmDjkRoute" msprop:Generator_UserDSName="CDmDjkRoute">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="DJK_ROUTE" msprop:Generator_TableClassName="DJK_ROUTEDataTable" msprop:Generator_TableVarName="tableDJK_ROUTE" msprop:Generator_TablePropName="DJK_ROUTE" msprop:Generator_RowDeletingName="DJK_ROUTERowDeleting" msprop:Generator_RowChangingName="DJK_ROUTERowChanging" msprop:Generator_RowEvHandlerName="DJK_ROUTERowChangeEventHandler" msprop:Generator_RowDeletedName="DJK_ROUTERowDeleted" msprop:Generator_UserTableName="DJK_ROUTE" msprop:Generator_RowChangedName="DJK_ROUTERowChanged" msprop:Generator_RowEvArgName="DJK_ROUTERowChangeEvent" msprop:Generator_RowClassName="DJK_ROUTERow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ROUTE_ID" msprop:Generator_ColumnVarNameInTable="columnROUTE_ID" msprop:Generator_ColumnPropNameInRow="ROUTE_ID" msprop:Generator_ColumnPropNameInTable="ROUTE_IDColumn" msprop:Generator_UserColumnName="ROUTE_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ROUTE_TITEL" msprop:Generator_ColumnVarNameInTable="columnROUTE_TITEL" msprop:Generator_ColumnPropNameInRow="ROUTE_TITEL" msprop:Generator_ColumnPropNameInTable="ROUTE_TITELColumn" msprop:Generator_UserColumnName="ROUTE_TITEL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="INTRODUCTION" msprop:Generator_ColumnVarNameInTable="columnINTRODUCTION" msprop:Generator_ColumnPropNameInRow="INTRODUCTION" msprop:Generator_ColumnPropNameInTable="INTRODUCTIONColumn" msprop:Generator_UserColumnName="INTRODUCTION" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ROUTE_CHARACTERISTIC" msprop:Generator_ColumnVarNameInTable="columnROUTE_CHARACTERISTIC" msprop:Generator_ColumnPropNameInRow="ROUTE_CHARACTERISTIC" msprop:Generator_ColumnPropNameInTable="ROUTE_CHARACTERISTICColumn" msprop:Generator_UserColumnName="ROUTE_CHARACTERISTIC" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ROUTE_COUNTRY" msprop:Generator_ColumnVarNameInTable="columnROUTE_COUNTRY" msprop:Generator_ColumnPropNameInRow="ROUTE_COUNTRY" msprop:Generator_ColumnPropNameInTable="ROUTE_COUNTRYColumn" msprop:Generator_UserColumnName="ROUTE_COUNTRY" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ROUTE_PROVINCE" msprop:Generator_ColumnVarNameInTable="columnROUTE_PROVINCE" msprop:Generator_ColumnPropNameInRow="ROUTE_PROVINCE" msprop:Generator_ColumnPropNameInTable="ROUTE_PROVINCEColumn" msprop:Generator_UserColumnName="ROUTE_PROVINCE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ROUTE_AREA" msprop:Generator_ColumnVarNameInTable="columnROUTE_AREA" msprop:Generator_ColumnPropNameInRow="ROUTE_AREA" msprop:Generator_ColumnPropNameInTable="ROUTE_AREAColumn" msprop:Generator_UserColumnName="ROUTE_AREA" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="COVERAGE_SCENIC_SPOTS" msprop:Generator_ColumnVarNameInTable="columnCOVERAGE_SCENIC_SPOTS" msprop:Generator_ColumnPropNameInRow="COVERAGE_SCENIC_SPOTS" msprop:Generator_ColumnPropNameInTable="COVERAGE_SCENIC_SPOTSColumn" msprop:Generator_UserColumnName="COVERAGE_SCENIC_SPOTS" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="COVERAGE_AREA" msprop:Generator_ColumnVarNameInTable="columnCOVERAGE_AREA" msprop:Generator_ColumnPropNameInRow="COVERAGE_AREA" msprop:Generator_ColumnPropNameInTable="COVERAGE_AREAColumn" msprop:Generator_UserColumnName="COVERAGE_AREA" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IMAGE_EXPLAIN" msprop:Generator_ColumnVarNameInTable="columnIMAGE_EXPLAIN" msprop:Generator_ColumnPropNameInRow="IMAGE_EXPLAIN" msprop:Generator_ColumnPropNameInTable="IMAGE_EXPLAINColumn" msprop:Generator_UserColumnName="IMAGE_EXPLAIN" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ROUTE_INTRODUCTION" msprop:Generator_ColumnVarNameInTable="columnROUTE_INTRODUCTION" msprop:Generator_ColumnPropNameInRow="ROUTE_INTRODUCTION" msprop:Generator_ColumnPropNameInTable="ROUTE_INTRODUCTIONColumn" msprop:Generator_UserColumnName="ROUTE_INTRODUCTION" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ROUTE_PRIC" msprop:Generator_ColumnVarNameInTable="columnROUTE_PRIC" msprop:Generator_ColumnPropNameInRow="ROUTE_PRIC" msprop:Generator_ColumnPropNameInTable="ROUTE_PRICColumn" msprop:Generator_UserColumnName="ROUTE_PRIC" type="xs:decimal" minOccurs="0" />
              <xs:element name="CREATE_TIME" msprop:Generator_ColumnVarNameInTable="columnCREATE_TIME" msprop:Generator_ColumnPropNameInRow="CREATE_TIME" msprop:Generator_ColumnPropNameInTable="CREATE_TIMEColumn" msprop:Generator_UserColumnName="CREATE_TIME" type="xs:dateTime" minOccurs="0" />
              <xs:element name="IS_DELETE" msprop:Generator_ColumnVarNameInTable="columnIS_DELETE" msprop:Generator_ColumnPropNameInRow="IS_DELETE" msprop:Generator_ColumnPropNameInTable="IS_DELETEColumn" msprop:Generator_UserColumnName="IS_DELETE" type="xs:boolean" />
              <xs:element name="IS_DJKINFO" msprop:Generator_ColumnVarNameInTable="columnIS_DJKINFO" msprop:Generator_ColumnPropNameInRow="IS_DJKINFO" msprop:Generator_ColumnPropNameInTable="IS_DJKINFOColumn" msprop:Generator_UserColumnName="IS_DJKINFO" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DJK_ROUTE" />
      <xs:field xpath="mstns:ROUTE_ID" />
    </xs:unique>
  </xs:element>
</xs:schema>